UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAc2ghQgpivOwCWJRmJv8Yit7sSKMvwvmdMu3/XFkqk='
WHERE
key_id = 'c9314c10e7f58d995a11450212c19295c67746a08cf96d117afc94bf6efc0cee'
AND (
token = 'HAc2ghQgpivOwCWJRmJv8Yit7sSKMvwvmdMu3/XFkqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)