UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqnSkRw0brqifINPc3oiwW+gmY0kyt3NDrzt9amy1yY='
WHERE
key_id = 'c3df6f7ae3f74bf2d9b310095f3983392d208ccf86da0468bf09189e107fdf27'
AND (
token = 'XqnSkRw0brqifINPc3oiwW+gmY0kyt3NDrzt9amy1yY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)