UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtYDIFuzd0C/C5+G7Wf8sUpir9bJNbETTfPan4BLZHk='
WHERE
key_id = '0d8a17422d9bf6dc06bf641f8d842dbc63f018b1b3f9d056eb0f0fd26a81fb48'
AND (
token = 'CtYDIFuzd0C/C5+G7Wf8sUpir9bJNbETTfPan4BLZHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)