UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D8Oz3Be/jK2cxEpr8s1l2cA9gi9tDCyAm2V01gbZVjA='
WHERE
key_id = '956333aa946e15e2abe82e385d6bffe9aca12085c6bdae2985e4ed076d4e6a8a'
AND (
token = 'D8Oz3Be/jK2cxEpr8s1l2cA9gi9tDCyAm2V01gbZVjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)