UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jfyx5nqkofafFZQXalIaLbepkIdnG5qRNPTWUcNmcY8='
WHERE
key_id = '81625678e728136f2cc6d901510895cd767bed9d7cb831fb7f715bf18b563061'
AND (
token = 'jfyx5nqkofafFZQXalIaLbepkIdnG5qRNPTWUcNmcY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)