UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zo7gdKXUQl8cw3/UQkxSl+oA62awW3+tiph6RBRn43M='
WHERE
key_id = '0a9fc4e7300d7458adceeeb4b933c3e291c90041a4557b0460fd4e1b69d58708'
AND (
token = 'Zo7gdKXUQl8cw3/UQkxSl+oA62awW3+tiph6RBRn43M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)