UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gGq8HnlI6QlfwRJChS3DJdZZXrn7V+1dp54I/xrettI='
WHERE
key_id = '454ef5cd212f6361d1d1d1462319016dbb1734c6a02f25e273c23930ebe71464'
AND (
token = 'gGq8HnlI6QlfwRJChS3DJdZZXrn7V+1dp54I/xrettI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)