UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y2c+v+qTNZEIQDkFK3kLvB2tME4/Mayrbifgkp6456E='
WHERE
key_id = '8e0aef4bce17adae2833803f476500cf76cb28bce14f7f473ead2d1a58653a4d'
AND (
token = 'Y2c+v+qTNZEIQDkFK3kLvB2tME4/Mayrbifgkp6456E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)