UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWiN49+1U5G8HLhf1zRaWuSgTjeFVSBQyza5p2R58jU='
WHERE
key_id = 'c1e35cdbd8b33eb79009460891e4d4273926a7db0007c9390e726a1e06c66573'
AND (
token = 'zWiN49+1U5G8HLhf1zRaWuSgTjeFVSBQyza5p2R58jU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)