UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJAXxDkPEhymrdlJTswcgzx4QmnbA1xXh4NO93MoLgg='
WHERE
key_id = '71a4186496433e81b900c4f9181105e4ea6b61c98e31db23d448bc45f97a12ab'
AND (
token = 'NJAXxDkPEhymrdlJTswcgzx4QmnbA1xXh4NO93MoLgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)