UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q8Pcz5cVvJKVPE1hIV96IhWgJwcKxok5AZKY303EBFg='
WHERE
key_id = 'cad03a00bd68f16e3d2df142f1c7722d496b21a5891b6702b1b4169d2133d088'
AND (
token = 'Q8Pcz5cVvJKVPE1hIV96IhWgJwcKxok5AZKY303EBFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)