UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NpN8D9Gl2B5TsikCrcLcbsOydoSu8NbP/D4CDbUfRqU='
WHERE
key_id = '3e824e0aa1999f3cc11fe070e8ea9a943330a92b41d50b17408aeda4bc9b62b6'
AND (
token = 'NpN8D9Gl2B5TsikCrcLcbsOydoSu8NbP/D4CDbUfRqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)