UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8WEsH3wK13TnYltnREeb6501tIYSXGOV622Y/veeKWU='
WHERE
key_id = 'e644e54feb8abc2d5371eeff2cf3bc0d83b089c31bdf952decd349ed5719f3ee'
AND (
token = '8WEsH3wK13TnYltnREeb6501tIYSXGOV622Y/veeKWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)