UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lnxui/aWVQFTUWRDmOHUWDH+ypwoUnGwHr34/jqT1Go='
WHERE
key_id = '0734676766a5f49d1444b66b9421c30385fb6561b708cb3316fd38dda78d905c'
AND (
token = 'Lnxui/aWVQFTUWRDmOHUWDH+ypwoUnGwHr34/jqT1Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)