UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+PTbIhKxS0ky4Vn5MSOP3I4m5KQvbqkvrtXoWLipbHw='
WHERE
key_id = 'e77f9f2f9290dca17f8276e15b61a91f20b33e84d370e8768e0195fb5eddf1a1'
AND (
token = '+PTbIhKxS0ky4Vn5MSOP3I4m5KQvbqkvrtXoWLipbHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)