UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJdzYj67T6Zxmh5EpaGKpZLy7aIG2/2uYyKYbyedmuE='
WHERE
key_id = 'f6308856b4a169d09279c1d4e04ea05daac7aca56e12094c46ef789c55d5bcbd'
AND (
token = 'bJdzYj67T6Zxmh5EpaGKpZLy7aIG2/2uYyKYbyedmuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)