UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zk+lcsc3xFNjSmQ4oQuIBt67x0JmDgef7trQdzwIPUQ='
WHERE
key_id = '554dc01e7d2a933c5918e8a9c0d411b8093893027999ac8bdfbb01681c4734ed'
AND (
token = 'zk+lcsc3xFNjSmQ4oQuIBt67x0JmDgef7trQdzwIPUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)