UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CGZw23SH8HuQh+kU6IUXCpomdipmzF1+223lFYLQmc='
WHERE
key_id = '2ee9fdf5c82c699a49ce45b87ec703ad38ebb96384859293a616793e7a4a0644'
AND (
token = '/CGZw23SH8HuQh+kU6IUXCpomdipmzF1+223lFYLQmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)