UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acJOgMBd4gr2BZFmiYvV/Cmtm231DjWbIWkdo7wZkJM='
WHERE
key_id = 'd9dbfc9787adebbb795958bf0446b7f696d6b203197d8d6ca69066863057a2ed'
AND (
token = 'acJOgMBd4gr2BZFmiYvV/Cmtm231DjWbIWkdo7wZkJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)