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