UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7M5oPV5rVA1VE3+cdwdN6Ut94Fkv1IeWA82K76Ys65w='
WHERE
key_id = '231ba8c49b52eacdec4d4261162983887aa5e9b5215445ad29e1465812b708ae'
AND (
token = '7M5oPV5rVA1VE3+cdwdN6Ut94Fkv1IeWA82K76Ys65w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)