UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TmZjL+BRUruhza3/8HN0PUB9Sp2TtNUThz+U5uG8S/s='
WHERE
key_id = 'c1a155433a6c2a6ff91f123b3dd44e78587223d994d4fa78fbaa3398f70cb60b'
AND (
token = 'TmZjL+BRUruhza3/8HN0PUB9Sp2TtNUThz+U5uG8S/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)