UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fdbuSfzUKXFM3zM0xSbPLZOYMg0jDc9VirDdOYtM+eo='
WHERE
key_id = '42c38fc78050d394086b919cda14e844977febada0e5a43d8a96afb8a39a9504'
AND (
token = 'fdbuSfzUKXFM3zM0xSbPLZOYMg0jDc9VirDdOYtM+eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)