UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DZ3F9xOMlzM9iD5S7Y+uvhA8L1YihiUgQLmdezawS4='
WHERE
key_id = '669aa78f1dbb162af25815dcd35f07d6f06ec06d7775a43f1f2a3ee3b9a7eccb'
AND (
token = '7DZ3F9xOMlzM9iD5S7Y+uvhA8L1YihiUgQLmdezawS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)