UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'njEeIrhsdepHNPWcu9tITI9Vn0CHqV+qvAuFsAtYXbg='
WHERE
key_id = 'aca8abb9cd45bfdcffdc56475818588d038f8da1f90ebbac510b22c5cb368386'
AND (
token = 'njEeIrhsdepHNPWcu9tITI9Vn0CHqV+qvAuFsAtYXbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)