UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7e0GJcO4II+dMx1SqDfLlP3VaOf40cgwAJyvI0ZH5E='
WHERE
key_id = '12f90c2fd68dc206062b62ff47a9b9e75fcd0bf8b8e0f4d902b56b9564c76476'
AND (
token = 'D7e0GJcO4II+dMx1SqDfLlP3VaOf40cgwAJyvI0ZH5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)