UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZjEc02q/HwLZTRXpGOwg+XTvzVFLhJKoW2+FRbti/w='
WHERE
key_id = 'bc551423bf6c564456ac130482968af30936d1044e6d98e4f82368066f2f4ebc'
AND (
token = 'kZjEc02q/HwLZTRXpGOwg+XTvzVFLhJKoW2+FRbti/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)