UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WiqSYO0+z3r4lMBh8NAt6XOdp2DmLfW28DqOp+JEJCk='
WHERE
key_id = '8c9979154a2128f20c1d42fcb62fa89505a74a0cacfa2a289a8b984b0d84c759'
AND (
token = 'WiqSYO0+z3r4lMBh8NAt6XOdp2DmLfW28DqOp+JEJCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)