UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqGg0gdG77n34gJUfipo6H9nsqc11HyZ/8gWWYq4sU8='
WHERE
key_id = '8e4e6a994d040d00592f5c033f34236a152b2cd68f8ee550ce55c77642b9b25f'
AND (
token = 'hqGg0gdG77n34gJUfipo6H9nsqc11HyZ/8gWWYq4sU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)