UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L8PvbLw6oK/vJwHaRsdxLNouU8G37joKUMgick77xu0='
WHERE
key_id = 'fb4a3ef71e1c86845b4dbf4d252930790637446b4279d52b5a4ba3babe6f109c'
AND (
token = 'L8PvbLw6oK/vJwHaRsdxLNouU8G37joKUMgick77xu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)