UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTGlrMSdXcQS6lRSwWaVnTEkToee8cGt7729xLgv+9Y='
WHERE
key_id = 'ce9248a6912c6bab9671d927fffad5068ffabc92ebdbcc60d287d6103d3f7712'
AND (
token = 'sTGlrMSdXcQS6lRSwWaVnTEkToee8cGt7729xLgv+9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)