UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgGQKZvN6llD0CHL4nrvjaesevgVa3Bfmil7ZG6qQyk='
WHERE
key_id = '974c78e69552a9540fa136408cabf0d7dd8e4b195e92f6a2a14bb76d835c470e'
AND (
token = 'BgGQKZvN6llD0CHL4nrvjaesevgVa3Bfmil7ZG6qQyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)