UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmdP0j/Qo7zF3Rn4KLy9OKn1OcEbBrXjG7CtW/m53Hk='
WHERE
key_id = 'b4321a33e5580c845f5a345581d3876da55bb8cf864d4479a7e2ee17d1071578'
AND (
token = 'XmdP0j/Qo7zF3Rn4KLy9OKn1OcEbBrXjG7CtW/m53Hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)