UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lEij6iPmH2x0SKAnGQZIiLwVpEok5nMqtpya4b4Iscc='
WHERE
key_id = 'c13747a4bcdb7e08a8633e4c3caaecce867da639c780c776150760ce283f9c7f'
AND (
token = 'lEij6iPmH2x0SKAnGQZIiLwVpEok5nMqtpya4b4Iscc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)